Saxon Global
BI/SQL Developer
Saxon Global, West Chicago, Illinois, United States, 60185
Must Have Skills: Great personality and communication, Microsoft SQL (SSIS, TSQL)
This position requires a technical individual that has the ability to communicate clearly with other IT professionals using technically sound terminology and excellent communication skills.
The ideal candidate will be a self starter working in a fairly autonomous environment. They will need to have experience coding technically sound solutions following industry best practices specifically around Enterprise data presentation solutions. This candidate will have the ability to work on multiple workstreams at any given time. The candidate will possess institutional knowledge of the insurance and Enterprise Data Services industries in order to craft the most effective and efficient solutions for the business. The ability to understand complex business needs, logical problem solving skills, and strong written and verbal communication skills are required. Additionally, an understanding of database methodology and the MS BI stack are required.Responsibilities:Simultaneously address multiple units of work within a given timeframe/sprint to ensure timeline is adhered to, quality requirements are followed and acceptance criteria is met.Use Microsoft BI stack (SQL, SSIS, SSRS, SSAS) to develop Data Integration solutions as part of the continued development and maturation of the Enterprise Data assetsWork with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance processAssure Data Integration solutions follow the department's software development lifecycle processes and that all required artifacts and documentation have been created to support a seamless migration to the Enterprise Data Operations Support teamDemonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management DisciplinesDeploy solutions with written implementation, test and back-out plans according to the change control processDrive and own the necessary development tasks to support functional specificationsProvide assistance to tier 4 support for Enterprise Data Assets and other legacy data stores/solutions. (Note: Tier 1 support is our NOC, tier 2 support is off-shore, tier 3 support is onshore and tier 4 support are our Sr. and Lead Data Integration developers)Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flowApply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work productWork within an agile environment following sprint commitments and release schedulesAdditional Duties:Actively participate in team meetings to support the groupActively participate in the culture of excellence as part of a BI delivery teamActively participate in team design reviews and co-operative architecture design sessionsWork directly with Sr Enterprise Information Delivery Developers, Enterprise Business Intelligence& Analytics Developers and Enterprise Business/Data Analysts on data requirements and quality assuranceWork efficiently and Effectively to ensure successful and timely completion of assigned project deliverablesWork with manager to effectively define and manage toward goals that impact personal, team and company related objectivesCreate and manage timelines for all Enterprise Data Integration team membersDrive and manage meetings that sole purpose is to communicate status of an individual team member's project workload
Work Experience, Education, Certification / Training Required:Bachelor's degree or equivalent certifications / experience required2+ years IT development experience required. Operational and/or Incident management experience a plus1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plusFundamental understanding of relational and dimensional databases requiredFundamental database and SQL experience required. Microsoft T-SQL preferredExperience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)Hands on experience with Microsoft SQL Server preferred. SQL Server 2012 Required and 2016 a plusExperience in the Insurance industry and/or LOMA coursework; ALMI designation a plusITIL Foundation V3 Certification a plus
Knowledge, Skills and Abilities Required:Strong aptitude to pick up new skills and knowledge through research and perseveranceThe adaptability to work in an everchanging and dynamic environmentAbility to think outside the box to provide innovative solutionsSelf-starter that can initiate research and/or contact with others in order to solve issuesEmbrace team environment and successTechnically capable to perform job responsibilities and passion for technical growthWillingness not only to understand the technical nature of the task, but to build the subject domain knowledge around why the task is being done and how the results are being utilized by the businessStrong communication skills
This position requires a technical individual that has the ability to communicate clearly with other IT professionals using technically sound terminology and excellent communication skills.
The ideal candidate will be a self starter working in a fairly autonomous environment. They will need to have experience coding technically sound solutions following industry best practices specifically around Enterprise data presentation solutions. This candidate will have the ability to work on multiple workstreams at any given time. The candidate will possess institutional knowledge of the insurance and Enterprise Data Services industries in order to craft the most effective and efficient solutions for the business. The ability to understand complex business needs, logical problem solving skills, and strong written and verbal communication skills are required. Additionally, an understanding of database methodology and the MS BI stack are required.Responsibilities:Simultaneously address multiple units of work within a given timeframe/sprint to ensure timeline is adhered to, quality requirements are followed and acceptance criteria is met.Use Microsoft BI stack (SQL, SSIS, SSRS, SSAS) to develop Data Integration solutions as part of the continued development and maturation of the Enterprise Data assetsWork with the Enterprise Data Services team to assure attributes are properly managed and governed via the Enterprise Data Governance processAssure Data Integration solutions follow the department's software development lifecycle processes and that all required artifacts and documentation have been created to support a seamless migration to the Enterprise Data Operations Support teamDemonstrate experience with ETL Methodologies, Incident Management, Change Management, Problem Management and Project Management DisciplinesDeploy solutions with written implementation, test and back-out plans according to the change control processDrive and own the necessary development tasks to support functional specificationsProvide assistance to tier 4 support for Enterprise Data Assets and other legacy data stores/solutions. (Note: Tier 1 support is our NOC, tier 2 support is off-shore, tier 3 support is onshore and tier 4 support are our Sr. and Lead Data Integration developers)Demonstrate a fundamental understanding of Enterprise Data Assets and other legacy data stores/solutions architecture, processes and flowApply Protective Enterprise Data Services standards in all development to ensure consistency and quality of work productWork within an agile environment following sprint commitments and release schedulesAdditional Duties:Actively participate in team meetings to support the groupActively participate in the culture of excellence as part of a BI delivery teamActively participate in team design reviews and co-operative architecture design sessionsWork directly with Sr Enterprise Information Delivery Developers, Enterprise Business Intelligence& Analytics Developers and Enterprise Business/Data Analysts on data requirements and quality assuranceWork efficiently and Effectively to ensure successful and timely completion of assigned project deliverablesWork with manager to effectively define and manage toward goals that impact personal, team and company related objectivesCreate and manage timelines for all Enterprise Data Integration team membersDrive and manage meetings that sole purpose is to communicate status of an individual team member's project workload
Work Experience, Education, Certification / Training Required:Bachelor's degree or equivalent certifications / experience required2+ years IT development experience required. Operational and/or Incident management experience a plus1+ years of Business Intelligence application delivery using the Microsoft Business Intelligence stack (SSIS, SQL Server) a plusFundamental understanding of relational and dimensional databases requiredFundamental database and SQL experience required. Microsoft T-SQL preferredExperience working on a project team using a waterfall and/or agile SDLC methodology required (Agile preferred)Hands on experience with Microsoft SQL Server preferred. SQL Server 2012 Required and 2016 a plusExperience in the Insurance industry and/or LOMA coursework; ALMI designation a plusITIL Foundation V3 Certification a plus
Knowledge, Skills and Abilities Required:Strong aptitude to pick up new skills and knowledge through research and perseveranceThe adaptability to work in an everchanging and dynamic environmentAbility to think outside the box to provide innovative solutionsSelf-starter that can initiate research and/or contact with others in order to solve issuesEmbrace team environment and successTechnically capable to perform job responsibilities and passion for technical growthWillingness not only to understand the technical nature of the task, but to build the subject domain knowledge around why the task is being done and how the results are being utilized by the businessStrong communication skills