Sr. Data Engineer - Milwaukee, United States - Constellation Search Group

    Default job background
    Description


    Senior BI Developer/Data Engineer who will design, development, and support of data pipelines from multiple applications and sources to facilitate data analytics needs.

    Our team partners with Sales & Marketing, Finance, and Operations business users and data scientists to help develop data driven insights and make data-driven decisions.

    The Senior BI Developer works with various data and BI tools and technologies, such as Python, SQL Server, Google Big Query, Google Cloud Composer, and etc.


    What you'll be doing:
    Develop data pipelines from multiple sources using Python with API calls.


    Develop SQL code or data flow to integrate and transform data from multiple sources into useful, consistent and easily consumable data elements.

    Work with business analysts and business users to understand data requirements and map into easy consumable data elements.

    Provide ongoing enhancement and support for data pipelines in the production environment. Understand critical needs of the business, identify and fix issues with a sense of urgency.

    Participate in discussions on design options and approaches, propose solutions and develop the new capabilities.

    Perform and lead the code reviews to identify coding, process and functionality improvements.

    Work on troubleshooting, identifying issues and performance bottlenecks, problem solving and impact analysis.

    Follow the Scrum process and take ownership of Jira stories.

    Lead the offshore developers, provide directions and guide them with development and support processes.

    What you'll need to be successful:

    Bachelor of Science in Computer Science, Engineering or related field

    Self-motivated with a strong work ethic, ability to work independently as well as ability to work within a team

    Strong communication skills, ability to communicate well with technical and non-technical staff

    3+ years experience working with Python or .NET programming

    3+ years of experience working with ETL and SQL development

    3+ years of experience working with cloud data platform, GCP, Azure or AWS

    Strong analytical and problem solving skills including the ability to independently troubleshoot issues and determine and develop the best solution while considering all impacts to the production system

    Willing to learn and able to adapt to new technologies as needed


    Benefits:
    Complete insurance coverage starting on first day of employment

    medical, dental, vision, life

    401(k) with company match

    Tuition reimbursement

    Bonus opportunity

    Vacation and holiday pay

    #J-18808-Ljbffr