Data Engineer Associate

Who We AreEide Bailly is one of the top 25 CPA and business advisory firms in the nation. We have over 40 offices in15 states across the Midwest and western United States and offer our staff and Partners the opportunityto serve a variety of industries. In 2019, we extended our operations to Mumbai, India, and desire toexpand our shared services segment there. Founded in 1917, our culture is the foundation of who weare, and we pride ourselves on supporting our employees to help them achieve their goals and pursuetheir interests both in the office and at home. At Eide Bailly we are passionate about the clients weserve, the work we do, and most importantly, having fun while we do itWhy You'll Love Working HereAt Eide Bailly we believe respect is how to treat everyone, not just those you want to impress. Ourculture focuses on collaboration to achieve career growth. Innovation is highly encouraged, which iswhere programs like our EB Xchange originate. This program allows interested tax and audit employeesto complete a rotation into a specialty area. We promote happy employees by making work/life balancea priority along with being actively involved in our communities. Our dedication to service can be seenthrough the Firm's decision to match charitable donations made by employees, as well as providingopportunities to volunteer throughout the year. Most importantly, we like to have fun We offer aprofessional and fun work environment with frequent lunch and learns, socials, contests, outings andother events.  A Typical Day in the LifeA typical day as a Data Engineer Associate might include the following:• Builds ETL processes to extract data from multiple sources to build and maintain the data lake.• Works with service areas to transform data by auditing and staging data for analytic application.• Creates data models including but not limited to fact and dimension tables to support reporting technologies such as OLAP cubes, Tableau, Power BI and Alteryx.• Uses problem solving and creativity to apply appropriate techniques in the creation of robust, scalable, and reproducible data processing assets.• Leverages source control and pipeline tools such as Github, GitLab, or Git for ADO to maintain documentation and controls of what is delivered to the target data engineering environment providing a full description of how the information is delivered and to what environment and stage of development.• Provides guidance and reviews systems for security and governance compliance.• Ensures timely and accurate performance on assigned projects.• Maintains compliance with project budgets, turnaround times, and deadlines. • Monitors platform and application stability and initiates incident and escalations to both internal teams and external vendors.• Troubleshooting, Root Cause analysis, implementation, and retrospective activities to overcome break-fix incidents and harden data pipelines to be more robust, stable, and scalable. Who You Are• Bachelor's degree in Information Systems, Computer Science, a related field, or equivalent work experience.• Minor in mathematics, statistics, accounting, finance, or other quantitative discipline, preferred. • 2+ years work experience as a data engineer, software developer, or equivalent technology profession.Knowledge of:• ETL processes and tools. Data orchestration and preparation best practices.• MPP systems such as MS Data Factory & Synapse, Snowflake, Delta Lake. MS Fabric preferred.• Streaming technologies, such as Microsoft, Kafka, Kinesis, Lambda and Spark.• SDLC Lifecycle.• Medallion Lakehouse concept data warehousing model (Bronze > Silver > Gold).Experience in at least one of the following:• MS SQL – SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services.• Python Language.• Cloud Data technologies – Azure and AWS.• Data modeling using the Kimball method (Star schema).• Exposure to DevOps tools and concepts to schedule, build, and release deliverables in a controlled and reproducible environment.• Comfortable with uncertainty. Projects and assignments will change rapidly, so must be flexible enough to accommodate changing priorities and timelines.• Ability to work independently and motivated to take on assigned tasks without hands-on input.• Motivation to learn and apply a complex skillset for data engineering or data science.• Strong interpersonal skills and can maintain effective working relationships with staff, partners, public and external agencies.• Ability to adapt with the project management lifecycle working with program managers, business analysts and other data professionals.• Must possess intellectual and analytical curiosity -- initiative to dig into the "why" of various results and a desire to grow responsibility and become a domain expert and strategic thought leader.What to Expect Next: We'll be in touch If you look like the right fit for our position, one of our recruiters will be reaching out to schedule a phone interview with you to learn more about your career interests and goals. In the meantime, we encourage you to check us out on Facebook, Twitter, Instagram, TikTok or our About Us page.