Education and Years of Experience:
Bachelors of Science and 7-10 years minumum
Required and Desired Skills/Certifications:
The Candidate should have the following skills:
a. Database and analytical skills.
b. Ability to query source data.
c. Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
d. Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
e. Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
f. Ability to:
(1) Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
(2) Critically think and problem solve,
(3) Provide excellent communication and mentoring needs,
(4) Quickly evaluate, learn and prototype new technologies.
(5) Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
g. Experience with:
(1) BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
(2) Dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions.
(3) Designing and building BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, data mapping, monitoring performance and communicating functional and technical issues.
(4) Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.
(5) Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.
(6) Designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified.
(7) Normalization process
(8) Performing the design and extension of data marts, meta data, and data models.
(9) Ensuring all data warehouse architecture codes are maintained in a version control system.
(10) Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS and stored procedures
(11) Advanced experience developing codes, testing for quality assurance, administering RDBMS.
(12) High proficiency in dimensional modeling techniques and their applications
(13) Azure’s architecture in order to structure optimized data workflows.
(14) The following tools:
i Power BI
ii Tableau
iii Azure Synapse
iv Azure Data Factory
v Azure Blob Storage
vi Azure Databricks
vii Microsoft Fabric
viii One Lake
Additional Requirements:
Min Citizenship Status Required: Must be a U.S. Citizen
Physical Requirements: No Physical requirement needed for this position.
Location: Hybrid, Three days a week on-site in Annapolis, MD, US and two days at an approved remote site.
Working at DMI
DMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:
- Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.
- Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.
- Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.
- Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.
- Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.
Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.
***************** No Agencies Please *****************
Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.