Sr. Data Engineer

Our mission is to change as many lives as possible by offering immigration solutions even in the most difficult cases. We look at all possible options to keep our clients in the United States with their families where they belong. We stand ready to fight even when success seems unsure because we understand how much better life can be with the dignity and peace of mind that comes with having documents.

About the role

A Sr Data Engineer will be responsible for designing, developing, and maintaining scalable data solutions that enhance our data infrastructure and support business insights. This role involves collaborating closely with cross-functional teams to ensure effective integration, processing, and data analysis across platforms.

Schedule

Monday to Friday 9am-6pm EST

What you'll do

1. Data Integration & Pipeline Development: Design and manage ELT/ETL pipelines (Azure Data Factory) to integrate data from Salesforce and other sources into Azure SQL; implement Python for data transformation and automation.
2. Database & Performance Optimization: Ensure database performance through tuning, partitioning, indexing, and use of best practices. Manage changes using Git.
3. Data Warehousing: Familiarity with Data Warehousing concepts (e.g., star schema data modeling) and experience implementing in a Data Warehouse, Mart, Lakehouse, or similar architecture.
4. Automation & Workflow Management: Use Azure Logic Apps and Power Automate to streamline and automate data workflows and reduce manual tasks.
5. Data Governance, Quality & Security: Apply data governance, quality, and security standards across platforms in compliance with applicable regulations and best practices.
6. Stakeholder Collaboration & Support: Work with analysts, developers, and business users to translate data needs into scalable solutions. Support Power BI dashboarding and provide mentoring to junior engineers.
7. Documentation & Monitoring: Maintain clear documentation for processes, pipelines, and architecture. Build monitoring solutions for performance and health checks.

Qualifications
Minimum Education and Experience Requirements (Essential Skills, Knowledge & Abilities)

1. Bachelor's in Computer Science, Data Engineering, or a related field.
2. 5+ years of experience in data engineering, with a focus on cloud-based solutions and data pipeline development.
3. Azure SQL, Data Factory, Logic Apps, and DevOps required.
4. Python for scripting and automation required.
5. Git for version control and CI/CD pipeline management (optional) required.
6. Power BI for reporting and semantic modeling required.
7. Familiarity with data governance, security, and workflow automation in Azure required.

People Leadership and Management

Executes supervisory responsibilities in accordance with the Firm's policies and applicable laws. Responsibilities include providing guidance, support, and direction to team members; conducting performance evaluations; fostering a collaborative and inclusive work environment; ensuring adherence to Firm policies and procedures; and contributing to team member development and operational goals.

Physical Demands & Work Environment

The physical demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to primarily sit, stand or walk; handle or feel objects, reach with hands and arms; talk and hear. Specific vision abilities required by the job include close vision, distance vision, and ability to focus. The employee must be able to lift up to five (5) pounds, as needed, without assistance.

While performing duties of this job, the employee is regularly exposed to an assigned office locations or the employee's home office. One must have the ability to travel as required by the needs of the Firm.

#J-18808-Ljbffr

---