Sr. Data and Analytics Developer - Baton Rouge, LA

Turner Industries is a fully diversified industrial contractor. We help move the world forward by providing responsive, innovative solutions designed to increase plant production, reduce costs, reduce downtime, and even prevent shutdowns. Headquartered in Baton Rouge, LA, Turner Industries has over 20,000 employees with offices and job sites across the United States. Our single-solution approach in the petrochemical, refining, energy, pulp and paper, and related industries has made Turner one of the nation's top industrial contractors and earned us the No. 1 spot on ABC's 2024 Top Performers list. People are at the heart of everything we do. Their safety, security, and satisfaction have always been our top priorities. For proof, look no further than our strong working relationships and extraordinary workforce.

Turner Industries Group has an opening for a Sr. Data and Analytics Developer to join our Information Technology team in the Baton Rouge, LA area. The Senior Data and Analytics Developer at Turner Industries is responsible for understanding, analyzing, querying, and modeling data and KPIs for large data warehousing projects. The ideal candidate will work within the team and with the other senior Data and Analytics developer to carry a project from conception to completion.

Essential Qualifications:

• Excellent soft skills
• Ability to work closely with a team
• Strong project management skills with support, oversight, and guidance from the Data and Analytics Manager
• Strong T-SQL skills
• Depth of experience working with RDBMSs, with a strong preference for Microsoft SQL Server, and some experience with DB2 preferred but not required
• Minimum 2 years experience with Power BI, to include:
  • Understanding Power BI Semantic Models
  • Understanding Power Query
• Minimum 3 years experience with cloud data platforms (Google BigQuery, Snowflake, etc)
• Minimum 6 years experience utilizing dimensional modeling, with a deep understanding of the various types of fact tables and dimension types
• Minimum 8years of general Data and Analytics development experience
• Bachelor's degree in computer science, computer information systems, or an adjacent technical field

Functional Requirements:

Responsible for understanding, analyzing, querying, and modeling data and KPIs for large data warehousing projects; work within the team and with the other senior Data and Analytics developer to carry a project from conception to completion; have an expert level understanding of each facet of data warehousing; glean data and KPI needs from stakeholders, understand and profile existing data, model the final warehouse tables, and build the required ETL/ELT pipelines; have a deep understanding of dimensional modeling; understand the different dimension types, including slowly changing dimensions types 1 and 2, and in what scenarios each is appropriate; possess deep knowledge of ETL/ELT concepts and best practices; have a mix of experience writing code heavy data pipelines in platforms such as SQL or dbt and in GUI based platforms such as SSIS, Power BI Power Query, or Informatica; be equally comfortable building new data warehouse solutions and maintaining and updating existing ones; have a depth of experience working within 3NF OLTP platforms, specifically stored in RDBMSs; will occasionally need to build visuals in Power BI; have a basic working knowledge of building, configuring, and styling visuals in Power BI

Compensation

Final agreed upon compensation is based upon individual qualifications and experience.

Benefits

Depending on your employment status, benefits include health, dental, vision, life, ADD, voluntary life / ADD, disability benefits, leaves of absence, 401k, paid time off, paid holidays, telehealth access, and employee assistance program.

Physical Involvement:

Employee may be required to do the following: reaching in all directions, handling and manipulating objects and materials; coordinating the movement of eyes, hands and fingers to operate machines and equipment; lifting 30 to 50 pounds from ground level, waist level, and/or overhead; carrying objects, etc.; standing; sitting; walking; seeing with or without correction; hearing with or without correction.

Turner Industries is an equal employment opportunity employer. All qualified individuals will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, national origin, disability and/or protected veteran status in accordance with governing law.