Description

We are looking to add a Sr. Data Modeler to our growing team in Atlanta, GA. This individual is responsible for developing, monitoring, and maintaining/supporting dashboards, analytics, BI models, and data solutions that enables the business to make informed and timely decisions. Participates in all phases of the software development life cycle and ensures the delivery of quality Data product and BI Solutions according to system specifications, quality requirements and company standards. In addition, works collaboratively with other team members and business analysist, actively participates in peer reviews, and contributes to process improvements.

What You Will Do

• Develop business intelligence and data warehousing solutions to meet business needs
• Work with Business analysts and BI team to develop data solution and documentation
• Participate in scheduled Agile meetings
• Ensures timely delivery in compliance with specifications and project plans
• Analyzes features and user requirements to create user stories, design specifications and provides effort estimation for development
• Writes well designed, flawless, secure, testable, and efficient code
• Data profiling to understand source data grain, enhance or modify existing data model
• Build and modify data pipelines and ETLs for loading source system data into the data warehouse for further reporting and analysis
• Maintain, monitor and troubleshoot existing ETL jobs, BI models
• Develop standard reports and dashboards based on business requirements
• Troubleshoot, fix and explain failures/errors in data or dashboards
• Develops unit-test code for robustness, including edge cases, usability, and general reliability
• Adopting best practices in the implementation and execution of support processes

Who You Are (Basic Qualifications)

• 5+ years of experience in Data Modeling
• 5+ years of experience and understanding of SQL (PL-SQL, stored procedure)
• Excellent understanding of Data warehouse, ETL, AWS architecture and Redshift
• 3+ years of experience in AWS, Glue, Python, and Redshift
• Experience with other AWS services like Step function, Lambda
• Experience with Distributed Computing using Apache Spark
• Experience with Power BI

What Will Put You Ahead

• AWS certifications like Solution Architect (SAA) or Data Analytics Specialty (DAS)
• Understanding of common DevOps/DataOps and CICD processes, methodologies, and technologies like GitLab, Terraform etc.
• IAM policies – and best practices with emphasis on custom security

At Koch companies, we are entrepreneurs. This means we openly challenge the status quo, find new ways to create value and get rewarded for our individual contributions. Any compensation range provided for a role is an estimate determined by available market data. The actual amount may be higher or lower than the range provided considering each candidate’s knowledge, skills, abilities, and geographic location. If you have questions, please speak to your recruiter about the flexibility and detail of our compensation philosophy.

Hiring Philosophy
All Koch companies value diversity of thought, perspectives, aptitudes, experiences, and backgrounds. We are Military Ready and Second Chance employers. Learn more about our hiring philosophy here.

At Koch, employees are empowered to do what they do best to make life better. Learn how our business philosophy helps employees unleash their potential while creating value for themselves and the company.

Our Benefits
Our goal is for each employee, and their families, to live fulfilling and healthy lives. We provide essential resources and support to build and maintain physical, financial, and emotional strength focusing on overall wellbeing so you can focus on what matters most. Our benefits plan includes medical, dental, vision, flexible spending and health savings accounts, life insurance, ADD, disability, retirement, paid vacation/time off, educational assistance, and may also include infertility assistance, paid parental leave and adoption assistance. Specific eligibility criteria is set by the applicable Summary Plan Description, policy or guideline and benefits may vary by geographic region. If you have questions on what benefits apply to you, please speak to your recruiter.

Equal Opportunities
Equal Opportunity Employer, including disability and protected veteran status. Except where prohibited by state law, all offers of employment are conditioned upon successfully passing a drug test. This employer uses E-Verify. Please visit the following website for additional information: http://www.kochcareers.com/doc/Everify.pdf

#LI-AJT