Data Engineer

Connexion Systems + Engineering

Remote, MA(remote)

Apply

JOB DETAILS

SALARY

$60–$90 Per Hour

LOCATION

Remote, MA

POSTED

30+ days ago

Data Engineer

3-year contract, fully remote

Pay Range: $60-$90/hr

Our Business Intelligence and Data Analytics Team is leading a journey to advance the use of analytics across the organization. We aim to make data readily accessible and trusted, accelerate the time-to-insight, and enable deep-dive analysis on an array of information. In collaboration with our partners, our projects aim to uncover the story hidden in the data and to leverage data science techniques to predict outcomes and inform next actions.

Key responsibilities include but not limited to:
-Data Engineer with strong business intelligence and data integration experience
-Design, develop, and support enterprise data and analytics solutions
-Build scalable data pipelines across multiple platforms
-Integrate data from diverse source systems
-Enable reporting and analytics using strong SQL, data virtualization, and API-based data connectivity
-Write and optimize SQL queries to extract, transform, and load data.
-Create and maintain technical documentation for data flows, integration points, and support procedures.
-Build and enhance Power BI solutions, including semantic models, dataflows, dashboards, reports, and reusable analytics assets.
-Develop advanced Power Query (M) transformations to support ingestion, cleansing, and shaping of data.
-Write, optimize, and maintain advanced DAX measures, calculated columns, and calculations to support business reporting and analytics.
-Design and maintain Semantic Models, including data modeling, relationships, hierarchies, and row-level security.
-Create impactful reports and visualizations in Power BI, including use of bookmarks and interactive user experiences.
-Support and enhance Dataflows and shared datasets to promote scalable and reusable analytics architecture.
-Collaborate with cross-functional teams to understand data needs and deliver actionable insights that meet business needs.
-Stay up-to-date with the latest trends and technologies in data analytics and visualization.
-Mentorship and guidance to provide technical leadership to team members and citizen developers across the organization.

Must Have:
-Deep hands-on experience with SQL, including advanced query development, optimization, performance tuning, and data transformation.
-Strong experience with data virtualization technologies and enterprise integration patterns.
-Proven experience with API integrations, including REST/SOAP services, authentication methods, JSON/XML payloads, and automated ingestion processes.
-Advanced experience with Power Query (m query language).
-Advanced experience with DAX (writing and optimizing).
-Experience with Dataflows.
-Experience with Semantic Models (modeling and row level security).
-Experience with Reports (visualizations and bookmarks).
-Experience with measures and calculated columns.

Nice to have:
--Hands-on experience with Denodo and similar data virtualization platforms
-SQL Server Administration
-Power BI Rest API and Integrate Deployments into CI/CD pipelines.
-Proficiency in Python for data manipulation and task automation.
-Microsoft Fabric.
-Microsoft Power Apps.
-Microsoft Power Automate.

Key soft skills:
-Discipline. Leverage standard best-practice approaches to managing work. Organized, thorough, and well documented.
-Eager to learn. We frequently introduce new toolsets and need the team to adapt.
-Collaboration. Actively inclusive with all stakeholders at various levels of the organization. Openly solicits ideas and feedback.
-Problem Solving. Anticipates obstacles and considers a broad range of alternatives. Involves others to overcome issues. Not afraid to escalate trouble.
-Autonomy. Works independently and is confident using sound discretion and judgement.
-Leadership. Capable of leading tasks, projects, or programs within the working group.

Working from home:
This position is REMOTE. The candidate is able to work remotely from any location. They may be asked to take up to 4 trips per calendar year to Lexington if the program/project requires it. Candidates must be able to support EST hours.

Clearance:
Willing to review candidates who can obtain an interim clearance. Candidates with an ACTIVE secret are HIGHLY preferred.

Interview process:
1st round interview will be Zoom with hiring manager. 2nd round interview will be Zoom with additional team members as needed

About the Company

Connexion Systems + Engineering

Connexion is an award-winning professional staffing firm that strives to be the unrivaled staffing solution for job seekers by expertly connecting talent with opportunity. Over the last 20 years Connexion has built the most admired team of staffing experts in the industry. We give back, change lives and offer unconditional support to the candidates we represent.

Put Connexion's 20 years of experience to work for you! Our professionals have unrivaled relationships and contacts with the hiring managers, human resources team and decision makers at the most desirable companies to work for.

Don't let your resume get lost in an inbox, Connexion's recruiting team will advocate on your behalf to get you the job you want

COMPANY SIZE

500 to 999 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

1999

WEBSITE

https://www.csetalent.com/