> Markdown version of [/jobs/ext/1964306-data-analyst](https://www.wearedevelopers.com/jobs/ext/1964306-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Propertyvalue Quantum Technologies Llc - **Location:** Brooklyn, MI, United States - **Experience:** Expert - **Salary:** $166,400.0 - **Contract:** Temporary contract - **Skills:** Customer Information Control System (CICS), COBOL (Programming Language), Profiling, Data Dictionary, Extract Transform Load (ETL), Data Mapping, Data Mart, Data Profiling, Data Structures, Data Warehousing, IBM DB2, Relational Databases, Database Design, Database Queries, IBM InfoSphere DataStage, Distributed Data Store, IBM Mainframe, Mainframes, Microsoft SQL Server, Windows Servers, Standard Sql, Software Systems, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Virtual Storage Access Methods, Mainframe Programming, Git, Data Management, Control M - **Published:** August 7, 2026 - **Apply:** https://www.dice.com/job-detail/df7c3c75-1448-4bcc-a4d4-b1165d746084 ## About the Role Mandatory Skills/Experience Data Analyst, SQL, ETL Minimum of five (5) years of source-to-target data mapping experience in a mixed Mainframe and Relational Database environments. Experience creating data dictionary documentation with business terms, valid values, and definitions. Experience converting/migrating VSAM data to relational/dimensional SQL distributed databases. Minimum of three (3) years of recent experience developing applications using IBM DataStage ETL. Experience extracting field references and calculated data from COBOL programs. Experience with BMC Control-M workload automation software. Experience with GIT version control software. Minimum of three (3) years of recent experience with Pension Administration systems. Technical Ability Mandatory: System Experience must have. Strong SQL knowledge working with complex queries and stored procedures. Proficiency in SSRS reports development. Strong analytical skills demonstrated by the ability to receive and analyze requirements and propose a suitable solution that adheres to the team s methodology. Ability to work in multiple environments: IBM Mainframe, Windows Server, and SQL Server. Proficiency in mainframe applications encompassing COBOL, CICS and DB2. Understanding of data structures and their relationship to ETL applications. Ability to develop complex SQL data validations based on STTMs and target data Models. Excellent analytical, problem-solving, and information gathering skills along with fundamental technical troubleshooting abilities. Desirable Skills/Experience Experience extracting business rules from the existing legacy code. Experience with Data Quality/Profiling tools. Experience with Data Warehouses/Data Marts. Experience with SQL Server Reporting Services (SSRS). Prior experience working in a pension system, preferably New York State or New York City pension system. ## Description The Senior Data Analyst with ETL Expertise shall provide Client Data Management team with technical expertise for the completion of Data Profiling/Cleansing, Conversion/Migration and Validation efforts as part of the Legacy Replacement initiative as well as Client ongoing process improvement programs. Scope of Services: The Senior Data Analyst with ETL Expertise will primarily be responsible for detailed field level analysis, metadata analysis, profiling, and mapping of VSAM files into relational/dimensional SQL tables as well as conversion/validation efforts as part of an enterprise-wide Legacy Replacement program. The Senior Data Analyst will create and maintain the master data dictionary, and assist in database design of Client mission-critical applications and inventory of its components. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [".Net is too slow" was not an option](https://www.wearedevelopers.com/videos/100176-net-is-too-slow-was-not-an-option) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Business Strategies for Scaling European Tech](https://www.wearedevelopers.com/videos/1694-business-strategies-for-scaling-european-tech) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)