TPI Global Solutions · 1 month ago
Senior SQL and Power BI Developer
United States
Full-time
Remote
Senior Level
7+ years expTPI Global Solutions is seeking a Senior SQL and Power BI Developer. The role involves developing Power BI dashboards and optimizing database solutions while leading complex IT applications design and implementation.
FinanceHuman ResourcesIT InfrastructureRecruitingStaffing Agency
Responsibilities
Developing Power BI dashboards with advanced DAX, data modeling, and performance tuning
Building and optimizing database solutions
Leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software
Planning, installing, configuring, testing, implementing and managing a systems environment in support of an organization’s IT architecture and business needs
Analyzing and refining systems requirements
Translating systems requirements into applications prototypes
Planning and designing systems architecture
Writing, debugging and maintaining code
Determining and designing applications architecture
Determining output media/formats
Designing user interfaces
Working with customers to test applications
Assuring software and systems quality and functionality
Integrating hardware and software components
Writing and maintaining program documentation
Evaluating new applications software technologies
Ensuring the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services
Analyzing systems requirements in response to business requirements, risks and costs
Evaluating, selecting, verifying and validating the systems software environment
Evaluating, selecting and installing compilers, assemblers and utilities
Monitoring and fine-tuning performance of the systems environment
Evaluating new systems engineering technologies and their effect on the operating environment
Ensuring that information security/information assurance policies, principles and practices are an integral element of the operating environment
Qualification
Required
Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming
At least four (4) years of that experience must have been in a lead capacity
4 years of experience in the past 7 years writing complex SQL queries, optimizing database performance, and ensuring data integrity across various database management systems, including Oracle, MySQL, SQL Server, and Azure SQL
3 years of experience in the past 4 years working with advanced skills in Oracle PL/SQL or similar procedural languages, adept at developing efficient stored procedures, triggers, and functions for seamless database operations
3 years of experience in the past 4 years working with designing and optimizing database schemas, ensuring scalability, data normalization, and efficient indexing for high-performance transactional systems
3 years of experience in the past 4 years working with developing intricate reports and visualizations using tools such as Cognos, Power BI, or Crystal Reports, transforming raw data into meaningful insights for diverse stakeholders
3 years of experience in the past 4 years working with Implementing robust ETL processes, integrating data from diverse sources into data warehouses flawlessly, ensuring accuracy, consistency, and reliability of data for analytical purposes
3 years of experience in the past 4 years working with Providing technical leadership to junior developers, conduct thorough code reviews, offer mentorship, and foster a collaborative environment within the team
2 years of experience in the past 4 years working with communicating complex technical concepts clearly to both technical and non-technical stakeholders, ensuring a shared understanding of database solutions and their alignment with business objectives
3 years of experience in the past 4 years working with complex database issues, debugging code, and optimizing queries for peak performance
2 years of experience building Power BI reports
2 years of experience in the past 4 years maintaining comprehensive documentation of database schemas, stored procedures, and ETL processes, ensuring knowledge accessibility and smooth transfer within the team
Possession of a bachelor's degree in an IT-related or Engineering field
Bachelors in computer science, data analytics, or a related field
Preferred
Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance
Proficiency extends to crafting queries that operate efficiently even with large datasets, ensuring optimal processing times and minimal resource usage
Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL
Exhibit a strong understanding and extensive experience in Oracle PL/SQL programming
Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information
Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting for automating and data manipulation
Exhibit a strong ability to optimize both database queries and underlying structures
Possess knowledge of data warehousing concepts and tools, enabling effective management of vast volumes of data
Display proficiency with Power BI, including crafting insightful visualizations and reports that translate raw data into valuable, actionable insights
Demonstrate proficiency in utilizing version control systems like Git to effectively manage and track changes in database scripts and queries
Company
TPI Global Solutions
TPI Global started in 1998, providing technical professionals to businesses scrambling to fix the Y2K bug.
201-500 employees
H1B Sponsorship
TPI Global Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
Funding
Current Stage
Growth StageLeadership Team
Claude Estes
Founder and CEO
Company data provided by crunchbase