SQL Database Developer Power BI 100% remote

Apply for this position Please mention DailyRemote when applying
Posted 12 days ago United States Salary undisclosed
Before you apply - make sure the job is legit.

Attempting to apply for jobs might take you off this site to a different website not owned by us. Any consequence as a result for attempting to apply for jobs is strictly at your own risk and we assume no liability.

Job Description

100% remote

A Database Developer and Modeler is required at this time to assist the Data Management Program handle increased work in the area of data analytics modeling and database development.

Performs as a Data Management database developer and database engineer in the realm of database design and creation, data ingestion, manipulation, and transformation in the course of building and maintaining data warehouses, data marts, including the management of meta data and meta marts. Initially, this work scope includes performing as a SQL Server Analysis Services developer and shall branch into broader database developer and engineer scope over time.

Responsible for the design of databases, data marts and other data deliverables in support of the hub. Once in the hub data warehouse, responsible for transformations and other activities to ensure that data marts and models are usable and sustainable. Includes the design and implementation of database modeling, both logical and physical, such as relational and/or dimensional models. Provides support to modelers and report builders.

Work to be performed:

  • Function independently on moderate to complex Database Administration activities. Responsibilities include handling security of Microsoft systems, tuning, backups, maintenance, and oversight of moderate to large Microsoft databases.
  • Provide technical support and multiple task management in the areas of systems analysis, database design, testing, and implementation for the successful completion and operations of SQL data bases, this includes writing SQL reports and programming.
  • Participate in upgrades and maintenance of databases.
  • Stays current on the emerging technologies including, but not limited to, Business Intelligence, Power BI, Microsoft SQL, Microsoft SSAS, ERWIN, and SAS.
  • All Subcontractor personnel performing work shall comply with all applicable requirements for work control, worker safety, and security. Training for the applicable work control requirements shall be provided by BEA for Subcontractor personnel.

Must have expertise in SQL databases, SQL security, tuning, backups, patching, maintenance, and implementation.

Must have experience in utilizing Microsoft SQL databases in application development.

Must understand different data models: normalized, de-normalized, star and snowflake models.

Must have strong hands-on experience in SQL Server and SQL Server Integration Services.

Must have experience in data warehousing/BI projects on Microsoft SQL Server Analysis Services (SSAS) and, specifically, tabular models.

- provided by Dice