One of our federal clients is looking for an outstanding data analyst to join their office a long-term basis. This position would last for at least a year with multiple option years and report 100% onsite to their office in downtown DC. This role will be responsible for programming and developing wide-ranging data visualization and analytical tools to support an audit-focused mission. Will interview and hire ASAP.
Duties: - Coordinate with staff and customers to identify business and technical requirements.
- Produce written documentation and artifacts for all work completed, including the translation of user requirements into technical designs.
- Assist the agency in the development of programming and visualization solutions.
- Troubleshoot and provide support on existing projects or application efforts.
- Understand the concepts supporting relational databases, data warehousing, data governance, data access, data quality and related areas.
- Engineer data analytic solutions, including prototyping, proof of concept, and full implementation.
- Evaluate, assess, document, and test data security and continuity of operations for systems and programs.
- Ensure compatibility between equipment and software, analyze operational/systems requirements, support design reviews, and present technical briefings.
- Perform analysis of data for Extraction, Transformation, and Load (ETL) strategies, pattern recognition, and application of analytical tools.
- Review, analyze, and modify existing products including coding, debugging, testing, and documenting.
- Provide guidance to coworkers on business and technical issues affecting projects, such as data access, data quality, storage capacity, and analytic tools and software.
- Assist with training and conference development which may include presentations to large audiences.
Requirements: - Knowledge of ODBC connection strings, and other external data source connection protocols.
- Expert proficiency in common data science tools, including scripted languages (such as SQL, Python, R, and Java Scripts), Integrated Development Environment and analytics platforms, open-source solutions, commercial off-the- shelf tools and hardware-based capabilities to support the data analytic development process and creating models, dashboards, and reports.
- Knowledge and experience using business intelligence applications and reporting technologies/methodologies including Data Analytics Expressions (DAX), data Mash-up(M), and Microsoft Power Platform (e.g., Power BI, Power Apps, Power Automate, etc.).
- Knowledge of AWS or Azure Services, including Databricks, Data Factory, and Data Lake.
- Knowledge of Extraction, Transformation, and Load (ETL) strategies, pattern recognition, and application of analytical tools.
- Knowledge of scripted languages such as SQL, Python, R, and Java Scripts and the proven ability to create solutions in complex environments, including the use of programming languages to create datasets, visualizations, and interactive reports in various business intelligence applications.
- Skill applying analytical techniques, methods, and processes to business problems demonstrated through a history of accepted modeling and analyses that resulted in meaningful business impact. These include working with unstructured or structured data and converting those data sets using a variety of analyses such as optimization, simulation, classical and spatial statistics, and/or programming languages.
- Strong writing and documentation skills to capture collection of source data, methodology from business rules, and visualization deployment from a myriad of sources and interactions with various stakeholders.
- Ability to facilitate between business owners and end-users who need to communicate with database administrators and traditional IT support staff.
- Ensure that quality/security guidelines are followed.
- Strong relational database and querying languages experience.
- Knowledge and experience in the law enforcement and/or audit industry
- Knowledge and experience using cloud computing platforms such as Azure
- Knowledge and experience with relational databases and structured query language (SQL)
- Specialized experience working with programming languages (e.g., Python), business intelligence tools (e.g., Power BI), and analytics platforms (e.g., Databricks).
- Degree in Computer Science, Information Technology, Data Analytics, or related field.
- 5+ years' experience and skill writing coding languages (such as SQL, Python, R, and Java Scripts).
- 3+ years' experience working with Microsoft Power Platform (including Power BI, Power Automate, Power Apps) and other business intelligence applications.
- At least 6 months' experience working with AWS or Azure services such as Databricks, Data Factory, and Data Lake.
- Professional Certification(s) in a related field of data science and/or data analytics disciplines preferred.
The Midtown Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We are a small, woman-owned business certified by the Women's Business Enterprise National Council (WBENC). Operating from our headquarters in Washington, DC, we provide trusted staffing services nationwide. Our clients include thousands of the most prestigious Fortune 500 companies, law firms, financial organizations, tech innovators, non-profits, and lobbying firms, as well as federal, state and local government agencies.