Data Analyst

Fts Inc; Alexandria (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

Fts Inc in Alexandria, VA is seeking a data engineer to design, build, and optimize data pipelines, databases, and data models that power business insights.

You will develop ETL/ELT processes, manage data cataloging with data.world, and create automated reports and workflows. Collaborate with analysts and application teams while ensuring data quality, governance, and secure use of AI-assisted tools.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• 2-4 years in data engineering, BI, databases, analytics, or integration.
• Strong SQL, relational DBs, and data modeling skills.
• Experience with ETL/ELT pipelines and data integrations.
• Experience with data governance, metadata management, and cataloging tools (data.world preferred).
• Experience with reporting tools like Power BI, Tableau, QuickSight, Salesforce reporting.
• Ability to gather requirements and translate into technical solutions.
• Familiarity with AI-assisted coding, testing, and documentation.

Responsibilities

• Build, test, and maintain data pipelines, databases, and data models.
• Develop and improve ETL/ELT processes between systems.
• Manage data cataloging with data.world—metadata, documentation, governance.
• Create automated reports, datasets, and workflows for operations and decisions.
• Collaborate with internal teams to gather requirements and implement solutions.
• Monitor data accuracy and troubleshoot integration issues.
• Build workflow automations using Zapier and Asana.
• Use AI-assisted tools like Copilot and Codex to support development while following security guidelines.
• Partner with analysts and data scientists to improve data accessibility and reporting.
• Maintain documentation of data processes and system integrations.
• Identify opportunities to streamline manual processes and improve systems.
• Test new reporting and automation solutions before rolling out.

Skills

SQL

Relational databases

Data modeling

ETL/ELT pipelines

Data governance

Data quality

Power BI

Tableau

QuickSight

Salesforce reporting

data.world

AI-assisted tools

Git

CI/CD

APIs

Security best practices

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Tableau

QuickSight

Salesforce reporting

Zapier

Asana

Power Automate

data.world

Git

CI/CD

AWS

Azure

Job description

• Build, test, and maintain data pipelines, databases, and data models.
• Develop and improve ETL/ELT processes to move and transform data between systems.
• Manage data cataloging activities using data.world, including metadata, documentation, data ownership, and governance.
• Create automated reports, datasets, and workflows to support business operations and decision-making.
• Work with internal teams to gather requirements and turn business needs into technical solutions.
• Monitor data accuracy, troubleshoot integration issues, and improve data quality.
• Build and maintain workflow automations using tools such as Zapier, Asana, and similar platforms.
• Use AI-assisted tools such as Microsoft Copilot and OpenAI Codex to support development, testing, documentation, and automation while following security guidelines.
• Partner with analysts, data scientists, and application teams to improve data accessibility and reporting.
• Maintain clear documentation of data processes, system integrations, technical solutions, and support procedures.
• Identify opportunities to improve existing systems and streamline manual processes.
• Test new reporting and automation solutions before implementing them for business users.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Information Systems, or a related field. Equivalent experience will also be considered.
• 2-4 years of experience in data engineering, business intelligence, database administration, analytics, systems integration, or a similar role.
• Strong working knowledge of SQL, relational databases, and data modeling.
• Experience developing or maintaining ETL/ELT pipelines, data integrations, and automated workflows.
• Familiarity with data governance, metadata management, data documentation, and cataloging tools. Experience with data.world is preferred.
• Experience with reporting tools such as Power BI, Tableau, QuickSight, Salesforce reporting, or similar platforms.
• Ability to gather business requirements, document processes, and develop solutions based on stakeholder needs.
• Familiarity with using AI-assisted tools responsibly for coding, analysis, testing, and documentation.
• Strong communication, organization, customer service, and problem-solving skills.
• Ability to work independently, manage multiple projects, and collaborate with both technical and nontechnical teams.

Preferred Technical Experience

• Understanding of ETL/ELT processes, data transformation, orchestration, monitoring, and change data capture.
• Knowledge of database structures, indexing, schemas, query optimization, and data quality practices.
• Experience with cloud and database technologies such as AWS, Azure, SQL Server, S3, Glue, DynamoDB, RDS, or Redshift.
• Familiarity with Microsoft tools such as Fabric, Power BI, PowerPivot, Power Apps, Power Automate, Azure App Service, and Microsoft 365 Copilot.
• Experience with Salesforce platforms, including Sales Cloud, Experience Cloud, Nonprofit Success Pack, or Marketing Cloud.
• Experience creating workflow automations using Zapier, Asana, Power Automate, or similar tools.
• Familiarity with Git, CI/CD, APIs, testing, and deployment processes.
• Exposure to containerization, infrastructure-as-code, or application integrations.
• Understanding of responsible AI practices, including reviewing generated code, protecting sensitive information, and validating results.
• Previous experience supporting nonprofit or mission-driven organizations is a plus.