Reston | Virginia | United States
We here at HRU Technical Resources have partnered with a leader in defense industry to find a Sr. Applications Developer in Reston, VA.
As an Applications Developer you will be part of a team responsible for Enterprise Business Intelligence. The right candidate for this position will have demonstrated a strong experience in data modeling and report/dashboard developing within the Microsoft Business Intelligence tool set. This position requires that the candidate understands, uses and applies technical standards, principles, theories, concepts and techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity. The candidate will also regularly interact with the customers to understand, document and communicate their needs, perform requirements analysis, develop and deliver reports and dashboards as per the requirements and contribute to the development and delivery of user training and documentation. The candidate will work under the general direction of the manager or the principal Systems Analyst and will independently determine and develop approach to solutions. The candidate will follow established procedures and contribute to the completion of milestones associated with specific projects and keep up to date with the technology shifts through training. This position requires a wide range of technical development, design, and multitasking skills. The ability to communicate effectively with members of the Products, Services, and Management teams are key components for success in this role.
Data Modeling/ETL/Data Warehousing
Demonstrated experience in designing, developing, deploying and maintaining MS SQL Server Analysis Services (SSAS) Tabular models and Multi-Dimensional Cubes, including partitioning and incremental synchronization of each.
Strong skills in writing DAX and MDX expressions/queries
Experience in design and development of relational and dimensional database models
Expertise in ETL between Homogenous and Heterogeneous Systems
Expertise with ETL workflow design using SQL Server Data Transformation Services (DTS)/Visual Studio and/or MS SQL Server Integration Services (SSIS).
Expertise in designing stored procedures/T-SQL coding, performance tuning, and query optimization.
Proficient in T-SQL for developing complex Stored Procedures, Triggers, Tables, user defined functions, relational database models and data integrity, and SQL joins.
Experience in logical and physical database design & development, data conversion, database normalization and data modelling.
Experience developing and managing data models in Microsoft Power Pivot for Excel Reports/dashboards/cubes (tabular/Dimensional/Tablix) development
Strong demonstrated skills designing, developing, and maintain Power BI and MS SQL Server Reporting Services (SSRS) reports
Write parameterized queries for generating tabular reports and sub reports using global variables, expressions, and functions
Experience with list reports, dashboards, scorecards, Matrix and Tablix reports, reports/dashboards with drill down capabilities
Expertise developing, deploying and enhancing data cubes and multi-dimensional dashboards
Strong expertise in writing, analyzing and improving query performance using T-SQL.
Experience writing, analyzing, modifying and improving stored procedures written using T-SQL
Experience writing, analyzing and improving DAX expressions and MDX queries
Experience with developing and delivering end user training
Experience in developing technical and process documentation Server Administration
Experience in database creation, maintenance, monitoring, backups and recoveries. System Administration
MS SQL Server 2012 – 2017 suite of products like SSIS, SSAS, and SSRS.
Experience designing, maintaining & tuning MS SQL Server and strong knowledge of SDLC principles.
Strong experience with migrating reports/dashboards between different BI applications and different BI development environments
Creating, updating and removing data source connections
Experience in implementing data level and application level security using SharePoint services
Experience in using version control apps such as Visual Source Safe (VSS), Subversion (SVN) or Microsoft Team Foundation Server (TFS) SharePoint Integration
Experience in integrating MS BI suite with SharePoint services such as Excel PowerPivot services for SharePoint, SharePoint security etc
MS SQL Server 2012 - 2017, SSAS, SSIS, Power BI, SSRS, T-SQL, ODBC, DTS, SQL Server Data Tools (SSDT)/Visual Studio, Oracle 11g or later, MS Office, Power Pivot for Excel, , MS Visio, XML, Windows server, .Net development, version control
These things make you a Rockstar:
Microsoft Analytics Platform System (APS)/Parallel Data Warehouse (PDW), Microsoft SharePoint development, Microsoft SharePoint server, Excel Services for Microsoft SharePoint, HTML, exposure to other analytic tools (i.e. Tableau)
Type: Contract to hire
Job Location: Reston, VA
Thank you. Please complete your application on the next page.
HRU has developed a large network of available candidates nationwide, as the company has been providing recruiting and staffing services in up to 22 States for over 25 years. We specialize in engineering, IT, technical and other support services. We are able to recruit and successfully place candidates in job openings in a variety of other fields and positions as well, such as human resources, administration, management, purchasing, sales, customer service, accounting, organic chemistry and more. HRU is able to service clients, regardless of location, by assigning an Account Manager and experienced Recruiters to provide the necessary staffing and support services. Likewise, HRU may assist job seekers anywhere in the United States, regardless of location.
This site uses technology such as cookies to give you a personalized experience. Click below to consent to the use of this technology.