Data Engineer (Python, MongoDB, Power BI and Data Extraction, Ability to Write Code)

Job Title: Data Engineer (Python, MongoDB, PowerBI and Data Extraction, ability to write code) Location: Hartford, CT Position type: W2 contract Mandatory Skills:- Serverless architecture, lambda, SQS,SNS, CloudFormation /Terraform scripts, Iac, IAM roles, Mongo, Python Overview We are seeking a motivated and skilled Data Engineer to join our team. The ideal candidate will have strong proficiency in Python, knowledge of MongoDB, and experience with Power BI. This role will primarily focus on building data extracts and data feeds for downstream systems, including Ledger, Reporting, and Boudreaux. You will be responsible for writing the code necessary to deliver the required data based on predefined definitions The Role Responsibilities • Data Extraction and Transformation: Write efficient and scalable Python code to extract and transform data from various sources, ensuring it meets the requirements for downstream systems. • MongoDB Management: Utilize MongoDB for storing and managing data. Design and optimize data models and queries to ensure high performance and reliability. • Power BI Integration: Collaborate with stakeholders to deliver data in a format suitable for reporting and visualization in Power BI. Ensure that the data aligns with business needs and reporting requirements. • Data Feed Development: Develop and maintain data feeds for downstream systems, including Ledger and Boudreaux, ensuring timely and accurate data delivery. • Collaboration with Stakeholders: Work closely with business analysts and other stakeholders to understand data definitions and requirements, translating them into technical specifications. • Documentation: Maintain comprehensive documentation of data pipelines, data models, and technical specifications to support knowledge sharing and compliance. • Quality Assurance: Implement data validation and quality checks to ensure the accuracy and integrity of the data being delivered. Requirements • Bachelor’s degree in Computer Science, Data Engineering, Information Technology, or a related field. • Minimum of 10 years of experience in data engineering or a related field. • Strong experience in Python programming, particularly in data manipulation and ETL processes. • Solid knowledge of MongoDB and experience in database design and management. • Familiarity with Power BI for creating reports and dashboards. • Experience in building data extracts and feeds for business applications. • Analytical Skills: Strong analytical and problem-solving skills with a focus on delivering high-quality data solutions. • Communication: Excellent verbal and written communication skills, with the ability to clearly convey technical concepts to both technical and non-technical stakeholders. • Team Player: Ability to work collaboratively in a fast-paced, team-oriented environment.